//医院表存储 test
CREATE TABLE [dbo].[xt_hospital](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [dh] [VARCHAR](250) NOT NULL,
    [mc] [VARCHAR](250) NOT NULL,
    [creatime] [DATETIME] NOT NULL)


    //log 记录表
CREATE TABLE [dbo].[xt_ac_qyb] (
    [qydh] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
    [qyname] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
    [sj] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
    [sj1] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL
    )
    ON [PRIMARY]
    GO

ALTER TABLE [dbo].[xt_ac_qyb] SET (LOCK_ESCALATION = TABLE)

CREATE TABLE [dbo].[xt_log_a](
    [id] [INT] IDENTITY(1,1) NOT NULL,
    [user] [VARCHAR](250) NOT NULL,
    [log] [VARCHAR](250) NOT NULL,
    [ybid] [VARCHAR](250) NOT NULL,
    [createdate] [DATETIME] NOT NULL,
    [show] [INT] NOT NULL,
    [sql] [VARCHAR](250) NOT NULL)


CREATE TABLE [dbo].[xt_log_highblood](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [xmdh] [nvarchar](50) NOT NULL,
    [xmcdz] [nvarchar](50) NOT NULL,
    [cdrq] [datetime] NOT NULL,
    [createtime] [datetime] NULL,
    [ybbh] [nvarchar](50) NOT NULL
    ) ON [PRIMARY]